<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="utf-8"/>
		<title>生产日报表</title>
		<meta name="viewport" content="width=device-width, initial-scale=1"/>
		<meta http-equiv="X-UA-Compatible" content="IE=edge" />
		<meta http-equiv="pragma" content="no-cache"/>
		<meta http-equiv="cache-control" content="no-cache"/>
		<meta http-equiv="expires" content="0"/>	
		<link rel="stylesheet" href="./4/lumen/bootstrap.css" media="screen"/>
		<link rel="stylesheet" href="./_assets/css/custom.min.css"/>
	</head>
<body>
	<div class="container">
		<form>
			<legend>生产日报表</legend>
			<div class="form-group row">
				<label class="col-sm-1 col-form-label" for="inputDefault">工序:</label>
				<div class="col-sm-2">
					<select name="WP" class="form-control" id="WP" type="text">
						<option value="齐纳">齐纳</option>
						<option value="固晶">固晶</option>
						<option value="焊线">焊线</option>
						<option value="点胶">点胶</option>
						<option value="切割">切割</option>
						<option value="分光">分光</option>
						<option value="编带">编带</option>
					</select>
				</div>
			  <label class="col-sm-1 col-form-label" for="inputDefault">班別:</label>
			  <div class="col-sm-1">
			  <input type="radio" class="form-check-input" name="optionsRadios" id="optionsRadios2" value="A">
				<label class="custom-control-label" for="customRadio1">A</label><br>
			  <input type="radio" class="form-check-input" name="optionsRadios" id="optionsRadios2" value="B">
				<label class="custom-control-label" for="customRadio1">B</label>
			  </div>
				<button type="button" id="ChaXun" >查詢</button>
				<button type="button" id="DaoChu" >導出</button>
			</div>	
			
			<div class="form-group row">
			  <label class="col-sm-1 col-form-label" for="inputDefault">日期:</label>
			  <div class="col-sm-2">
				<input   class="form-control"  id="RiQi" type="text"/>
			  </div>
			  
			  <label class="col-sm-1 col-form-label" for="inputDefault">周別:</label>
			  <div class="col-sm-1">
				<input   class="form-control"  id="ZhouBie" type="text"/>
			  </div>
			  
			  <label class="col-sm-1 col-form-label" for="inputDefault">製表人:</label>
			  <div class="col-sm-2">
				<input   class="form-control"  id="ZhiBiao" type="text"/>
			  </div>
			  
			</div>

			
			<div id="mytable"></div>
			
		</form>
			<div class="form-group row">
			  <div class="col-sm-2">
			  </div>
			  <div class="col-sm-2">
			  </div>
			  <div class="col-sm-2">
			  </div>
			  <div class="col-sm-2">
			  </div>
			  <div class="col-sm-2">
				<button type="button" id="Clearesqty" >保存</button>
			  </div>
			  <div class="col-sm-2">
				<button type="button" id="Clearesqty" >提交</button>
			  </div>
			</div>
			<div class="form-group row">
			</div>
		
		<p class="lead">
			<a class="btn btn-primary btn-lg" href="index.html" role="button">返回</a>
		</p>
	</div>
	
	<link rel="stylesheet" type="text/css" href="./jexcel-master/dist/css/jquery.jexcel.css" />
    <script src="./_vendor/jquery/dist/jquery.min.js"></script>
	<script src="./jexcel-master/dist/js/jquery.jexcel.js"></script>
    <script src="./_vendor/popper.js/dist/umd/popper.min.js"></script>
    <script src="./_vendor/bootstrap/dist/js/bootstrap.min.js"></script>
    <script src="./_assets/js/custom.js"></script>
	
	
	
<script>

	Plan_data = null; 
	//encodeURIComponent編碼
	//decodeURIComponent後端解碼
	var GongXu = encodeURIComponent($("#WP").val());//工序
	var DT = $("#RiQi").val();//日期
	console.log(DT);
	var BanBie = $("#optionsRadios2").val();//班別
	
	$(document).ready(function (){
		$.ajax({ url: "getPlan.php", 
			dataType : "json",
			success: function(data){
				Plan_data = data;
				$('#mytable').jexcel({ data:Plan_data,
					columns: [
						{ type:'text', readOnly:true },{ type:'text', readOnly:true },
						{ type:'text', wordWrap:true },{ type:'text', readOnly:true },
						{ type:'text', readOnly:true },{ type:'text', readOnly:true },
						{ type:'text', readOnly:true },{ type:'text', readOnly:true },
						{ type:'text', readOnly:true },{ type:'text', wordWrap:true },
						
					],		
					colHeaders:['工序','班別','机台号','工单','產品<br/>類型','產品系列',
								'產品型號','計劃產能<br/>(K)','排配工時<br/>(小时)','操作员<br/>(工号)',
								'实际產<br/>能(K)','实际工<br/>时(分钟)','正常運<br/>轉時間','待排配<br/>(待機)',
								'日點檢<br/>保養','工單切<br/>換調机','更換耗<br/>材','冶具清<br/>理',
								'首件','生產調<br/>机','工程試<br/>樣','設備故<br/>障停機',
								'品質異<br/>常停線','待料','水電氣<br/>異常','其他計<br/>劃外停<br/>機',
								'產能達<br/>成率','生產效<br/>率'],
					colWidths: [ 100,60,80,100,60,80,150,80,80,80,
								 50,60,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50 ]			
					
				});
				console.log(Plan_data);
			}
		});
	});
	$("#ChaXun").click(function(){
		$.ajax({ url: "getPlan.php?GongXu="+GongXu+"&BanBie="+BanBie,  //+"&DT="+DT
			dataType : "json",
			success: function(data){
				Plan_data = data;
				$('#mytable').jexcel({ data:Plan_data,
					columns: [
						{ type:'text', readOnly:true },{ type:'text', readOnly:true },
						{ type:'text', wordWrap:true },{ type:'text', readOnly:true },
						{ type:'text', readOnly:true },{ type:'text', readOnly:true },
						{ type:'text', readOnly:true },{ type:'text', readOnly:true },
						{ type:'text', readOnly:true },{ type:'text', wordWrap:true },
						
					],		
					colHeaders:['工序','班別','机台号','工单','產品<br/>類型','產品系列',
								'產品型號','計劃產能<br/>(K)','排配工時<br/>(小时)','操作员<br/>(工号)',
								'实际產<br/>能(K)','实际工<br/>时(分钟)','正常運<br/>轉時間','待排配<br/>(待機)',
								'日點檢<br/>保養','工單切<br/>換調机','更換耗<br/>材','冶具清<br/>理',
								'首件','生產調<br/>机','工程試<br/>樣','設備故<br/>障停機',
								'品質異<br/>常停線','待料','水電氣<br/>異常','其他計<br/>劃外停<br/>機',
								'產能達<br/>成率','生產效<br/>率'],
					colWidths: [ 100,60,80,100,60,80,150,80,80,80,
								 50,60,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50 ]			
					
				});
				console.log(Plan_data);
			}
		});
	});
	//默認日期(因為JS沒有日期格式化函數)
	var date = new Date
	var mm = ""
	var dd = ""
	if ((date.getMonth()+1)>9){
		mm=(date.getMonth()+1)
	}else{
		mm=0+""+(date.getMonth()+1)
	};
	if ((date.getDate()+1)>9){
		dd=(date.getDate())
	}else{
		dd=0+""+(date.getDate())
	};
	//2018-3-8
	//2018-03-08
	$("#RiQi").val(date.getFullYear()+"-"+mm+"-"+dd);
	
	$("#ZhouBie").val(getWeekOfYear(date))
	
	
	//一天含86,400,000毫秒(24*60*60*1000)
	//公式計算获取本周是一年中的第几周
	function getWeekOfYear(date){
	    var d1 = date;
	    var d2 = new Date(date.getFullYear(), 0, 1);
	    var d = Math.round((d1 - d2) / 86400000);
	    return Math.ceil((d + ((d2.getDay() + 1) - 1)) / 7);
	};
</script>
	
</body>
</html>
